UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+8LDqkajoCV8C0l+bZCwE/0cIO/VhbhLHyBvkI4rZJY='
WHERE
key_id = '793322a114975635feff530ef09e0a250fadc75920b108d24ebda85fd79ea6ea'
AND (
token = '+8LDqkajoCV8C0l+bZCwE/0cIO/VhbhLHyBvkI4rZJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)