UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JHJg1Muci/7hVZT3AkPyJ6WhOcLdev/lrDU/m74dcuI='
WHERE
key_id = 'de3bf47aa9835490d9c43363a66506cd2e82753b6b6026ff5aaabb0abc92e334'
AND (
token = 'JHJg1Muci/7hVZT3AkPyJ6WhOcLdev/lrDU/m74dcuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)