UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WIGxZA59mgvMg9lQWRRBAyUChJexPpiS+K8vQudTIk8='
WHERE
key_id = '24f42f7f14ae5c7037d0f52c182c0e3bb2784267361fb8f3d5d12f4107b2b8e2'
AND (
token = 'WIGxZA59mgvMg9lQWRRBAyUChJexPpiS+K8vQudTIk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)