UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BmDvg9Pc2axt/f9nmdGWLWwYLqgGj8w7P9uo3HDFDQs='
WHERE
key_id = '31c97526c616dd5e773669b17239ccdbad6335a8863325b770c6a5034d23e65a'
AND (
token = 'BmDvg9Pc2axt/f9nmdGWLWwYLqgGj8w7P9uo3HDFDQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)