UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pMHIrtfs+pPXTGBO3+ISpzbV85UkNW44a+xD1YXY5iE='
WHERE
key_id = '3cc631262451780ed9b42df76f58c3e66d2e52b79e13a32dbf3b6313abb504b9'
AND (
token = 'pMHIrtfs+pPXTGBO3+ISpzbV85UkNW44a+xD1YXY5iE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)