UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3b8cAIUd6XT3SGDqeOxsKWP+xY5Lp6N2KYW+xEg39+s='
WHERE
key_id = '5c6e4e40f20fd2d311f117201df299ecc17a5171c761eaffbd4902f0217d785e'
AND (
token = '3b8cAIUd6XT3SGDqeOxsKWP+xY5Lp6N2KYW+xEg39+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)