UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fh4IB9kgvih/7I7J6wAW6o8WaNVhO852Twdv9BJHOvI='
WHERE
key_id = 'acfd6fdb95815a26f3e83ef2df86fca140a823e21b708e95f7535525be13f9bd'
AND (
token = 'fh4IB9kgvih/7I7J6wAW6o8WaNVhO852Twdv9BJHOvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)