UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z3IHqYnUYKvmSvy1Fr7aMPqHnnVZ8f8uToFiyQ76FSo='
WHERE
key_id = '28faafdb5b86f0222d7390b05aa9ad09f590d6b3672f25218b31fce1ab8a56c1'
AND (
token = 'z3IHqYnUYKvmSvy1Fr7aMPqHnnVZ8f8uToFiyQ76FSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)