UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pUnsa/4ARCUc4p3boZIYUgd08Qk56T1fJpUGkNVgKD0='
WHERE
key_id = 'e175e67515c5d02948313a75ade938ca8b9d45e87e11cb71c2fa43b33a29318f'
AND (
token = 'pUnsa/4ARCUc4p3boZIYUgd08Qk56T1fJpUGkNVgKD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)