UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZo2sz+jK+pxghf10auUk5dypTGO13e3ReUzSGdDraA='
WHERE
key_id = 'bc265b7965b9c5dc97993758823c59fc5d0ea16db24f30cc4c5ba53d9518b9e5'
AND (
token = 'qZo2sz+jK+pxghf10auUk5dypTGO13e3ReUzSGdDraA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)