UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZRtQFRsBFuBnO1QrQsZyTr96azadvtVyYbcyPQGs5Y='
WHERE
key_id = '55403d0164e6b382d28140f9861ac9e8344c0671129bcfa0787f5ab3fbe4c80a'
AND (
token = '6ZRtQFRsBFuBnO1QrQsZyTr96azadvtVyYbcyPQGs5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)