UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f93pl/6wJ+R4vlEsoHYu+obtkvifeWRHMKpJRSd37c4='
WHERE
key_id = '1462bb474409ee13894e53e4ee7371cf8e8aab9d1eb96234be34ba85d8555fc4'
AND (
token = 'f93pl/6wJ+R4vlEsoHYu+obtkvifeWRHMKpJRSd37c4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)