UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f0HWLYQ1JDT2eHv4IKrKGlFaNMTJlXd2SYZGFLhF4f8='
WHERE
key_id = '00d1dde4a20900c6488ad6291a50a823197614b20119c5c8863b78aad839d92d'
AND (
token = 'f0HWLYQ1JDT2eHv4IKrKGlFaNMTJlXd2SYZGFLhF4f8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)