UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HExHZxb5MvTpwsgoP5xpVOwhe9J7mz6nmqjyrWAC7sw='
WHERE
key_id = '6dabd84a616767eee51d1c882b81fd789e262f56025e1da73f692b19f5bf23e4'
AND (
token = 'HExHZxb5MvTpwsgoP5xpVOwhe9J7mz6nmqjyrWAC7sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)