UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '389V/oDJ/gQzYaLZKuZBThWxD+GtgK7e0g1zX9/Ti5A='
WHERE
key_id = 'f47fd985e28498563489a75e1fac15d90f62cb23e14337a96b6fd47405d03467'
AND (
token = '389V/oDJ/gQzYaLZKuZBThWxD+GtgK7e0g1zX9/Ti5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)