UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/VIjhlJHx1vNcImMFvVbRx8/x0q8A7hZvwyhyAbHUww='
WHERE
key_id = '78b4cb6d82ed56241b390a370253510bdc6b26285c9f4677a10ca255dc1085d1'
AND (
token = '/VIjhlJHx1vNcImMFvVbRx8/x0q8A7hZvwyhyAbHUww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)