UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn5FgDz7kBqodvh30ESg4Hms1XOmklD7htp1RsHRrYM='
WHERE
key_id = '84a015699d586aba001fabf0a237b410c52b7983a2289fc2f5f83ff8efb1ff7e'
AND (
token = 'zn5FgDz7kBqodvh30ESg4Hms1XOmklD7htp1RsHRrYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)