UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6srePmFyLu10gt5TPH6/ZBsYxUJ4qKcgLiMAjV++wAM='
WHERE
key_id = '78117a61d18f4fcfc1066d7ef387ec458f78a4417a0f18e9f06782be1c08d614'
AND (
token = '6srePmFyLu10gt5TPH6/ZBsYxUJ4qKcgLiMAjV++wAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)