UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1oneNpTPhRQo4nhU5jedNdncfhAKRh9/s3ohCtmcJMs='
WHERE
key_id = 'b96f230304b4da9cdf2fb1ae897d7af192f23b7d5fefc70fbe69a2eae8d81cf6'
AND (
token = '1oneNpTPhRQo4nhU5jedNdncfhAKRh9/s3ohCtmcJMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)