UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SV3JE2OJdgu7mDHdQzN2xM20X7//BZeDVaIwjb08L0='
WHERE
key_id = '9873bb615fb099b0140a471ce578e7f8e202eaf11e55f472498153a7604a647b'
AND (
token = '3SV3JE2OJdgu7mDHdQzN2xM20X7//BZeDVaIwjb08L0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)