UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fw6gF9nXO9zd3vDcmdQG9UHgIhyFD0SX8INrAHxGKIc='
WHERE
key_id = '93f307311f937d1df3b6b8a8a39ed12aa16578c1c3a8fbff5c3d3352224a7b2d'
AND (
token = 'fw6gF9nXO9zd3vDcmdQG9UHgIhyFD0SX8INrAHxGKIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)