UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xcXsAe6W17vsjgoCRjLzbwCcnw025GtU9xxcpYQ6PyQ='
WHERE
key_id = 'ba082714ccaac83d15efea32cec61807969e6f182db4a94facba3b812df83289'
AND (
token = 'xcXsAe6W17vsjgoCRjLzbwCcnw025GtU9xxcpYQ6PyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)