UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZC8Eax9Zpd5BitYxTHXIgT1h0fA136LyzQHvgmbVK3Q='
WHERE
key_id = '52804e7ef4de7ec0831940d4595e43721903e22f69cfa3aeb338f319a628808d'
AND (
token = 'ZC8Eax9Zpd5BitYxTHXIgT1h0fA136LyzQHvgmbVK3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)