UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nD0nBTxAWoUyuSNNej/oa+0yMmkaWETkVjj9zlij9/c='
WHERE
key_id = 'd64ac65aa0109f296dbead60682bcc1c0dd068fd1888ff07e6667115c7a82157'
AND (
token = 'nD0nBTxAWoUyuSNNej/oa+0yMmkaWETkVjj9zlij9/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)