UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kcokhTO5/bdzyYz0vIOws+VfbpkjyLi4cYoRV8SxD4s='
WHERE
key_id = '781ae88aae82bf4ba94d0ee14e0e43bb0b4803eee809ae433440dafd8add15bc'
AND (
token = 'kcokhTO5/bdzyYz0vIOws+VfbpkjyLi4cYoRV8SxD4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)