UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1WhpY3acCJFCotDgVcwZl6rfKHhTIHUmI5/HJ3ub9iA='
WHERE
key_id = 'e33f7ea68f46a77d9f8fb92d4266114341a8e3acfeda86dd198cf1849c48ec55'
AND (
token = '1WhpY3acCJFCotDgVcwZl6rfKHhTIHUmI5/HJ3ub9iA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)