UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1D9NrmdmBRW8TtDLiFhhLrsJhnKbRbDJPeIhgSLW4KU='
WHERE
key_id = '0ca728be9d2bf5a7a08bc9fcfcfb4094371c755ec20397f60f67e425da9395ba'
AND (
token = '1D9NrmdmBRW8TtDLiFhhLrsJhnKbRbDJPeIhgSLW4KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)