UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TNFNWAabbp36iXwrAKWVlQlej40ChxuPvzr4dKQZbkY='
WHERE
key_id = '30b1380427e0c3d0cdf763bada417a777a1445c30396000d1111d55ba8fd77bd'
AND (
token = 'TNFNWAabbp36iXwrAKWVlQlej40ChxuPvzr4dKQZbkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)