UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TrgH2p3a7j/4iWR80BDtknt7AbByMwauiY/aYsVnzHU='
WHERE
key_id = 'c17b845a5d865252a488000f6dad7061b7056ece836a75177c3c8e478eec64c2'
AND (
token = 'TrgH2p3a7j/4iWR80BDtknt7AbByMwauiY/aYsVnzHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)