UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xR4LCIOE6cM8IJXjTO5fWbIi5hVUnNf4ShQOIy6rvYM='
WHERE
key_id = '87fb4c9378b1f0576a5b7a5f3ee5c3c6fb3ab87fa21aaf2f3c218063aa6fb1da'
AND (
token = 'xR4LCIOE6cM8IJXjTO5fWbIi5hVUnNf4ShQOIy6rvYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)