UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEJr7SNsCA/ns6XNvayzN/JsRbCM0/RlXjly7MzIUJA='
WHERE
key_id = '564aa00763a4b6ace67271d2ff0a13b2a9e8cb705a3cb287557882ba17c6682a'
AND (
token = 'XEJr7SNsCA/ns6XNvayzN/JsRbCM0/RlXjly7MzIUJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)