UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8W6fIgELy9K17MjnOcKmrKG8GfhkkCIHwZOJ18PljHc='
WHERE
key_id = '0d29b640771965b2531e7df558e722d302aa0fef1af34523b43c39c44812fa1c'
AND (
token = '8W6fIgELy9K17MjnOcKmrKG8GfhkkCIHwZOJ18PljHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)