UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6l78x30f55rkEsDBfCsEM2MkKPdJUYn1phnLtTl81HY='
WHERE
key_id = '3ad9a0b57da59ec85b2b10a8d3920e1a8a85da3426d0b68fd0dbf4276190fe2a'
AND (
token = '6l78x30f55rkEsDBfCsEM2MkKPdJUYn1phnLtTl81HY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)