UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVasx5URS002KxuilkRlkuzlSDY6vU+xS/0+Un7HwVE='
WHERE
key_id = '2993a8b117b73bfa30c9faabcbf9c039e403c55c9321db1de9e676ce3ead4847'
AND (
token = 'vVasx5URS002KxuilkRlkuzlSDY6vU+xS/0+Un7HwVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)