UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ytmE1UnsFd4Z7v9gKUCJ9ip6iKlOWCBJaK3YTIwBs0='
WHERE
key_id = '9627289abfaf731d285e3e452cec19f0f0473161b71499eb7799193d31b53bd7'
AND (
token = '/ytmE1UnsFd4Z7v9gKUCJ9ip6iKlOWCBJaK3YTIwBs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)