UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'inv8J4iNbFITz7ChI9ZlzcRXj9f+4cfSTdX8BK4L82A='
WHERE
key_id = '3244bb4bdb4491991956c2f1804019fa19985e996cc775d5a6f7a0bbf90debb4'
AND (
token = 'inv8J4iNbFITz7ChI9ZlzcRXj9f+4cfSTdX8BK4L82A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)